package me.codegenerator2.service;

import me.codegenerator2.exception.BadRequestException;
import me.codegenerator2.utils.CommonStringHandleUtil;
import me.codegenerator2.utils.excel.ParseExcelDataUtil;
import org.apache.commons.io.IOUtils;
import org.apache.commons.lang3.StringUtils;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.springframework.stereotype.Service;
import org.springframework.web.multipart.MultipartFile;

import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;
import java.util.Map;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;

/**
 * @author zhongfs
 */

public interface WWWGeneratorMysqlFromExcelService {

    /**
     * @param file      接收到的文件
     * @param tableName 指定的表名
     * @return String 字符串
     * @author zhongfs
     */
    String generatorMysqlFromExcel(MultipartFile file, String tableName) throws Exception;

    /**
     * @author zhongfs
     */
    byte[] generatorMysqlFromExcelZip(String comments, String fileName);

}
